At 19:38 +0300 on 10/05/1999, Ken J. Wright wrote:
> But just to clarify further, that only works with sql. Copy needs the '\'
> approach.
> So many choices ;-)
Copy doesn't need it at all, because you don't have quotes around the
fields. The following is from my 6.4.2:
testing=> \d test
Table = test
+-----------------------------+-----------------------------+-------+
| Field | Type | Length|
+-----------------------------+-----------------------------+-------+
| t | text | var |
+-----------------------------+-----------------------------+-------+
testing=> copy test from stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
>> This is a field without a quote.
>> Here the word 'field' is in quotes.
>> Isn't it nice to have one quote in this field?
>> \.
testing=> select * from test;
t
----------------------------------------------
This is a field without a quote.
Here the word 'field' is in quotes.
Isn't it nice to have one quote in this field?
(3 rows)
I hope this convinces you...
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma